package com.hos.db.create.sms;

/**
 * 文章
 * Created by guom on 2018/10/15.
 */
public class SmsTable {
    public static String tableName = "sms";
    public static String tableSMSId = "sms_id";//短信id
    public static String tableSMSType = "sms_type";//短信类型
    public static String tableSMSPhone = "sms_phone";// 短信手机号
    public static String tableSMSMsg = "sms_msg";// 短信信息
    public static String tableSMSSendTime = "sms_send_time";// 短信发送时间
    public static String tableSMSReadCound = "sms_read_count";// 短信读取数量

    public static String tableSMSIsVerifyIs  = "sms_is_verify";//true 有效的
    //
    public static String careteTable = "create table  "
            + tableName + " ( "
            + tableSMSId + "  int primary key not null auto_increment, "//主键
            + tableSMSType + " varchar(200), "
            + tableSMSPhone + " varchar(100),"
            + tableSMSMsg + " varchar(100), "
            + tableSMSSendTime + " datetime, "
            + tableSMSIsVerifyIs + " boolean, "
            + tableSMSReadCound + " int "
            + "); ";

}
